Desktop Computer Skills
Microsoft Office 2016: Beginning Access
Access 2016: Creating Forms & Queries
ds_msac2016_06_enus
Access 2016: Finding & Organizing Data
ds_msac2016_05_enus
Access 2016: Inserting, Importing, & Formatting Data
ds_msac2016_04_enus
Access 2016: Saving, Printing & Exporting Databases
ds_msac2016_02_enus
Access 2016: Tables, Fields, & Entries
ds_msac2016_03_enus
Access 2016: Using the Report & Analysis Tools
ds_msac2016_07_enus
Access 2016: Working with Databases
ds_msac2016_01_enus
Creating Relationships, Queries, Forms and Reports in Access 2016
mo_beac_a02_dt_enus
Introduction to the Access 2016 Interface, Database Management, and Tables
mo_beac_a01_dt_enus
Access 2016: Creating Forms & Queries
Lesson Objectives
Access 2016: Creating Forms & Queries
- Creating a data entry form using the wizard
- Using different form types
- Creating a data entry form from scratch
- Inserting text in a form
- Inserting data entry fields in a form
- Inserting a list box in a form
- Inserting check boxes in a form
- Inserting buttons in a form
- Reorganizing your form
- Adding information to your form
- Customizing the appearance of your form
- Editing your form's properties
- Creating a simple query
- Creating a crosstab query
- Performing a simple calculation
- Creating a calculated field
Overview/Description
Forms in Access 2016 are designed to help you visualize records and create new data entries more easily. Discover different ways to create and customize forms, and create and work with queries.
Target
Prerequisites: none
Access 2016: Finding & Organizing Data
Lesson Objectives
Access 2016: Finding & Organizing Data
- Sorting your data
- Filtering your data
- Locating a data value
- Replacing data values
- Editing your database indexes
- Finding duplicates in your database
Overview/Description
As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records.
Target
Prerequisites: none
Access 2016: Inserting, Importing, & Formatting Data
Lesson Objectives
Access 2016: Inserting, Importing, & Formatting Data
- Inserting data into your table
- Modifying the default editing settings
- Using external data in your database
- Importing your address book from Outlook
- Formatting your data
- Creating dropdown menus
- Creating data validation rules
- Creating labels
Overview/Description
There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data.
There is little value in an empty database table. Learn how to enter and import data, change formatting settings, create dropdown menus, enforce data validation, and create labels with your data.
Target
Prerequisites: none
Access 2016: Saving, Printing & Exporting Databases
Lesson Objectives
Access 2016: Saving, Printing & Exporting Databases
- Saving your data
- Saving regularly
- Protecting your database
- Printing items in your database
- Exporting your database
- Sending your database table via email
Overview/Description
Data is key for any database application, and you'll want to be able to save, protect, and share it. Discover how to save data, protect your database, print database items, export a database, and send tables via email in Access 2016.
Target
Prerequisites: none
Access 2016: Tables, Fields, & Entries
Lesson Objectives
Access 2016: Tables, Fields, & Entries
- Understanding your database
- Creating a table
- Organizing your database items
- Inserting fields in your table
- Formatting your database fields
- Editing your database field properties
- Linking data in different tables
- Managing data relationships
- Visualizing object dependencies
Overview/Description
To get the most out of Access 2016, you need to understand the structure and main elements of a database. Explore tables, primary keys, and relationships, and discover how to format and edit both fields and field properties.
Target
Prerequisites: none
Access 2016: Using the Report & Analysis Tools
Lesson Objectives
Access 2016: Using the Report & Analysis Tools
- Creating a quick report
- Creating your own database report
- Customizing your report
- Cleaning up your database
- Analyzing your database
Overview/Description
For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.
For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.
Target
Prerequisites: none
Access 2016: Working with Databases
Lesson Objectives
Access 2016: Working with Databases
- Creating a database
- Using database templates
- Understanding the interface
- Customizing the interface
- Customizing your Quick Access Toolbar
- Customizing the ribbon
Overview/Description
Access 2016 is the database application in the Microsoft Office 2016 suite. Discover how to open existing databases and create new ones, and learn how you can customize the interface, including the Quick Access Toolbar and ribbon.
Target
Prerequisites: none
Creating Relationships, Queries, Forms and Reports in Access 2016
Lesson Objectives
Creating Relationships, Queries, Forms and Reports in Access 2016
- start the course
- outline the different types of relationships and when they should be applied in Access 2016
- recognize the rules for creating relationships between tables in an Access 2016 database
- choose a primary key from table fields and set relationships between tables in Access 2016
- change form views and edit a form using Design View in Access 2016
- apply blank forms and quick start templates to an Access 2016 database
- modify data in a form in Access 2016
- modify data on a form and delete form records in Access 2016
- list the different query types available in Access 2016
- create and run queries in Access 2016
- create update, make table, and append queries in Access 2016
- use the Total Column and the Query Setup features in Access 2016
- modify and preview reports in Access 2016
- export and import data in different file formats in Access 2016
- set a relationship between fields, create a parameter query and report, and import data in Access 2016
Overview/Description
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
Creating Relationships, Queries, Forms and Reports in Access 2016
Lesson Objectives
Creating Relationships, Queries, Forms and Reports in Access 2016
- start the course
- outline the different types of relationships and when they should be applied in Access 2016
- recognize the rules for creating relationships between tables in an Access 2016 database
- choose a primary key from table fields and set relationships between tables in Access 2016
- change form views and edit a form using Design View in Access 2016
- apply blank forms and quick start templates to an Access 2016 database
- modify data in a form in Access 2016
- modify data on a form and delete form records in Access 2016
- list the different query types available in Access 2016
- create and run queries in Access 2016
- create update, make table, and append queries in Access 2016
- use the Total Column and the Query Setup features in Access 2016
- modify and preview reports in Access 2016
- export and import data in different file formats in Access 2016
- set a relationship between fields, create a parameter query and report, and import data in Access 2016
Overview/Description
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Queries, being the heart of Access 2016, allows searching and extraction of information from tables for analysis. In this course, you'll learn how to set primary keys, forming relationships between objects in a database. In addition, this course demonstrates how to design forms and reports for data input, and how to present information in a neat and organized format. In addition, you will learn various methods of exporting and importing data using Access 2016. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
Introduction to the Access 2016 Interface, Database Management, and Tables
Lesson Objectives
Introduction to the Access 2016 Interface, Database Management, and Tables
- start the course
- describe what a database is and the advantages of using a database for different purposes
- distinguish between data and information and outline key considerations when structuring a database
- identify new features in Access 2016
- describe the Access 2016 interface
- distinguish between database objects such as tables, queries, forms, and reports
- open, create, and save databases in Access 2016
- set various database options using the Access 2016 Backstage
- create a table using Datasheet and Design view in Access 2016
- switch table views and modify table fields in Access 2016
- work with table fields and data using the Design and Datasheet view in Access 2016
- modify table field properties in Access 2016
- apply sort options and filter types when working with table data in Access 2016
- create and modify a database in Access 2016
Overview/Description
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
Introduction to the Access 2016 Interface, Database Management, and Tables
Lesson Objectives
Introduction to the Access 2016 Interface, Database Management, and Tables
- start the course
- describe what a database is and the advantages of using a database for different purposes
- distinguish between data and information and outline key considerations when structuring a database
- identify new features in Access 2016
- describe the Access 2016 interface
- distinguish between database objects such as tables, queries, forms, and reports
- open, create, and save databases in Access 2016
- set various database options using the Access 2016 Backstage
- create a table using Datasheet and Design view in Access 2016
- switch table views and modify table fields in Access 2016
- work with table fields and data using the Design and Datasheet view in Access 2016
- modify table field properties in Access 2016
- apply sort options and filter types when working with table data in Access 2016
- create and modify a database in Access 2016
Overview/Description
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Microsoft Access 2016 makes it easy to create professional databases for home, and business use. In this course, you'll learn about the new interface and key new features introduced in Access 2016. In addition, you will learn how to structure and construct a database design for a particular purpose. Included in this course is a section on adding, and modifying tables and table fields using different methods and views. This course is one of a series in the SkillSoft learning path that covers Microsoft Access 2016 for beginners.
Target Audience
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
End users at all levels, including those who have little or no familiarity with Microsoft Access and more experienced Access users who want to learn about the new interface and features to create a database using Access 2016.
